Diagram UHCContracts_5

Defincja diagramu UHCContracts_5

Name

UHCContracts_5

Code

UHCContracts_5

Comment

 


Lista tabel diagramu

Name

Code

ActiveIngredientGroup

ActiveIngredientGroup

ActiveIngredientGroupDetails

ActiveIngredientGroupDetails

AdditionalPermission

AdditionalPermission

Address

Address

AdmCode

AdmCode

AdmCodeType

AdmCodeType

Country

Country

Dictionary

Dictionary

DrugInvoice

DrugInvoice

DrugPosition

DrugPosition

Insurance

Insurance

Insurer

Insurer

MedicalProductDefinition

MedicalProductDefinition

MedicalProductDetails

MedicalProductDetails

Patient

Patient

PermissionCode

PermissionCode

PermissionTitle

PermissionTitle


Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_81

R_81

PermissionTitle

PermissionCode

PermissionTitleID

 

 

R_82

R_82

PermissionCode

Insurance

PermissionCodeID

 

 

R_83

R_83

AdditionalPermission

Insurance

AdditionalPermissionID

 

 

R_84

R_84

AdmCode

Insurance

AdmCodeID

 

 

R_85

R_85

AdmCodeType

AdmCode

AdmCodeTypeID

 

 

R_86

R_86

Country

Insurance

CountryID

 

 

R_87

R_87

Country

Address

CountryID

 

 

R_89

R_89

Insurer

Insurance

InsurerID

 

 

R_170

R_170

PermissionTitle

Insurance

PermissionTitleID

 

 

R_195

R_195

DrugInvoice

DrugPosition

DrugInvoiceID

 

 

R_196

R_196

MedicalProductDefinition

DrugPosition

MedicalProductDefinitionID

 

 

R_411

R_411

AdmCode

Address

AdmCodeID

 

 

R_540

R_540

MedicalProductDefinition

MedicalProductDetails

MedicalProductDefinitionID

 

 

R_600

R_600

Patient

Insurance

DocumentHolderPersonID

 

 

R_605

R_605

DrugInvoice

DrugPosition

CorrectedDrugInvoiceID

 

 

R_606

R_606

DrugPosition

DrugPosition

CorrectedDrugPositionID

 

 

R_607

R_607

Address

DrugInvoice

ContractorAddressID

 

 

R_619

R_619

ActiveIngredientGroup

MedicalProductDefinition

ActiveIngredientGroupID

 

 

R_620

R_620

ActiveIngredientGroup

ActiveIngredientGroupDetails

activeIngredientGroupId

 

 

R_621

R_621

Dictionary

ActiveIngredientGroup

measureId

 

 

R_622

R_622

Dictionary

ActiveIngredientGroupDetails

typeId